DETALLESALIDAHQ

"192.168.0.1:sipop"

DETALLESALIDAHQ

Descriptions

DETALLE DE SALIDAS EN BODEGA DE HERRAMIENTAS Y EQUIPO

Fields

PK	FK	Name	Domain	Data type	Not null	Default	Description
		REGISTRO_SALIDA		CHAR (8)
		ARTICULO		CHAR (8)
		CANTIDAD		FLOAT
		COSTO_PROMEDIO		FLOAT
		COD_INGRESO		CHAR (8)

Triggers

Trigger	Type	Active	Position	Description
DETALLESALIDAHQ_AI	After Insert		0

Indices

There are no indices for table DETALLESALIDAHQ

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
INVENTARIO	INTEG_292	ARTICULO	ID_ARTICULO	RESTRICT	RESTRICT
REGISTROSALIDA	INTEG_294	REGISTRO_SALIDA	ID_REGISTRO_SALIDAD	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table DETALLESALIDAHQ

Definition


CREATE TABLE DETALLESALIDAHQ (
    REGISTRO_SALIDA CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    ARTICULO CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    CANTIDAD FLOAT NOT NULL,
    COSTO_PROMEDIO FLOAT,
    COD_INGRESO CHAR (8) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE DETALLESALIDAHQ ADD  FOREIGN KEY (ARTICULO) REFERENCES INVENTARIO (ID_ARTICULO);
ALTER TABLE DETALLESALIDAHQ ADD  FOREIGN KEY (REGISTRO_SALIDA) REFERENCES REGISTROSALIDA (ID_REGISTRO_SALIDAD);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.